subquery in LInQ EF Core C#

94

subquery in LInQ EF Core C# -

var accountBalance = context
    .AccountBalanceByDate
    .Where(a => 
        a.Date == context.AccountBalanceByDate
             .Where(b => b.AccountId == a.AccountId && b.Date < date).Max(b => b.Date));

Comments

Submit
0 Comments